Inner Join Necessary???

[WebmasterMama]

Its been forever since I've had to do an application and, not surprisingly, am having stupid difficulties. I have 3 tables. I need to output from each of them - all of the info - based on ID.

this is my query thus far... I am sure I'm missing some key stuff - maybe an Inner Join?? Thanks!!

<cfquery datasource="aqxdretire" name="allinfo">
select names.retireid, names.firstname, names.mi, names.lastname, names.fromdate, names.primaryemail, names.secondaryemail, names.matrixafsc, names.careerfld, names.certlvl, services.sandt, services.progmngt, services.contracting, services.engineering, locations.hanscom, locations.la, locations.wp, locations.edwards, locations.eglin, locations.tinker, locations.hill, locations.warner, locations.kirtland, locations.rome, locations.dc
from names, services, locations
WHERE names.retireid = services.retireid AND names.retireid = locations.retireid
</cfquery>

[paross1]

You are doing an "inner join" using the old syntax by including the tables in the FROM and "joining" them in the WHERE. What results are you getting that are different than what you expect?

Phil

[WebmasterMama]

I'm not getting any results. Just that I'm getting an error... that's it.

[Dan_Bracuk]

What's the error message? By the way, since you are requesting so many fields, a good format for debugging is:

select names.retireid
, names.firstname
, names.mi
, names.lastname
, etc
,locations.dc

from etc

It makes it easy to see if you are missing any commas.

[paross1]

If you have no results then your WHERE clause is to blame, and you have no case where the same retireid exists in all three tables. Are you sure that you want to be doing an INNER JOIN?

Phil