Join multi access database tables

[rfan99]

Anybody knows how to join multi Access database tables
by using LAbview SQL tool kit? It seems Labview SQL does not support "JOIN" feature.

Thanks

[Christopher Mitchell]

The following KB might provide some helpful information:

http://ae.natinst.com/operations/ae/public.nsf/fca7838c4500dc10862567a100753500/39e4bd5ecf72b629862565b8005b9e48?OpenDocument

[TLE]

Create a Query in Access that includes the tables and then refer to
the Query in LabVIEW using the SQL Toolkit.

This works for SELECT queries but in order to INSERT, you have to
treat each table independently.

[drval]

You might find using the DB Connectivity Toolset to be a more robust way to go....

[mgracietti]

Use "INNER JOIN" instead. It's the same as "JOIN" and works in LabVIEW.

[mgracietti]

But I still dont know how to join multiple tables.

I've tried:

SELECT  pd.NAME, pp.PART_ID, pp.MATERIAL, pt.NAME

FROM PRODUCT pd INNER JOIN LOOKUP_PRODUCTPART pp

     ON pd.PRODUCT_ID=pp.PRODUCT_ID INNER JOIN PART pt

     ON pp.PART_ID=pt.PART_ID

But it doesn't work. 

Hm.. the following (joinig two tables) works. It's shows that INNER JOIN works in LabVIEW:

SELECT  pd.NAME, pp.PART_ID, pp.MATERIAL, pt.NAME

FROM PRODUCT pd INNER JOIN LOOKUP_PRODUCTPART pp

     ON pd.PRODUCT_ID=pp.PRODUCT_ID 

[CappellaioMatto]

the problem is the use of ( ) in sql access. using de query buider in access you can create a inner join query and have a look. i post here a working inner join between 4 different tables.

SELECT F1.CODE, F4.ABS1_IOL, F5.SOFT_START_2, F3.PE_T
FROM (( F1 INNER JOIN F5 ON F1.CODE = F5.CODE) INNER JOIN
F4 ON F1.CODE = F4.CODE) INNER JOIN
F3 ON F1.CODE = F3.CODE;

REMEMBER THE BRAKETS.