I have 3 MS Access tables in database that are linked by keyed fields in the table. Is there a way to fetch only certain records that match a criteria across all three of these tables using the database connectivity toolset VIs?
Thanks. I am trying to mechanize/run an SQL query like this
SELECT Code_Type.Code_NUM, Code_Type.Code_Word, Word_Type.Parm_Label, Word_Type.Word_Sequence, Word_Type.Num_Words, Parameter_Label.Parm_Label, Parameter_Label.Parm_Name, Parameter_Label.Num_Bits, Parameter_Label.Num_Bits
FROM (Code_Type INNER JOIN Word_Type ON Code_Type.Code_Word = Word_Type.Code_Word) INNER JOIN Parameter_Label ON Word_Type.Parm_Label = Parameter_Label.Parm_Label;
while using the VIs in the database connectivity toolset. How do I code this using these VIs? I dont see an example of a straight SQL string like this being able to be put into the VIs.
Thanks, I got the SQL query to execute but how do I see all the results in a table? All I can get is a recordset ref returned where I have to navigate one record at a time....