Query Help

Last Post 05 Jun 2004 12:30 AM by BryanL. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
BryanL
New Member
New Member

--
29 May 2004 04:10 PM
Hello:

I have two tables

Table one includes a column that lists the statistical categories for an application. Basically a lookup up table.
100
101
102
501
...

Table two is a table that includes the value of the column in table one plus a column for the user i.d. Basically a table that store the defaults for ALL users.

88329 100
88329 501
88000 401
88125 321

How can I write a query that will display ALL the records in table one with a column that displays whether a selected user has subscribed to those values.

100 88329
102 null
102 null
501 88329
...


I can not seem to find a join that works as I need to add a where clause to the second table to filter the user.

Help

-=Bryan=-

BryanL
New Member
New Member

--
05 Jun 2004 12:30 AM
Thank you for the reply. I will give your suggestion a try.
You are not authorized to post a reply.

Acceptable Use Policy