Nested INNER JOIN problem

[u3003-04-23]

I worked it out. code below in case it helps anyone else out:

v1 from http://forums.devshed.com/showthread.php?s…=&postid=269096

SELECT v_pdf_info.*, v_pdf_cat.pdfCatTitle, v_pdf_diff.fldDesc

FROM v_pdf_diff

INNER JOIN v_pdf_info

ON v_pdf_diff.fldID = v_pdf_info.pdfdiff

INNER JOIN v_pdf_Cat

ON v_pdf_info.pdfCatID = v_pdf_Cat.pdfCatID

AND pdfID>0;

v2 from me:

SELECT v_pdf_info.*, v_pdf_cat.pdfCatTitle, v_pdf_diff.fldDesc

FROM v_pdf_diff, v_pdf_cat, v_pdf_info

where

v_pdf_cat.pdfCatID = v_pdf_info.pdfCatID

and

v_pdf_diff.fldID = v_pdf_info.pdfdiff

and

pdfID>0;

jim

[Author]

Posts