report query 1

[jtfrier]

I am trying to creat a report using a query i have 5 table in there with a primary key all joined to one main table I have another table that I need to get information from that does not have a relation ship with all the other table so when I add it to the query it will not run. I dont want to add the primary key field to this table if posible.

 

[Crowley16]

use a subquery...

--------------------
Procrastinate Now!

 

[jtfrier]

how do i do that?

 

[Crowley16]

lol...

select fldNme1, fldNme2,
(
select anotherFldNme from anotherTable
)
from table

--------------------
Procrastinate Now!

 

[jtfrier]

thanks for the help