selecting data from two tables

[future-architect]

I am trying to select data from two tables.  The only problem that I am running into, is that i am only seeing results from my 'uploads' table.  there is also a record in documents where user = 1 that should show up.  here is my sql:

$userIDNum = 1;

$sql="Select *

from uploads, documents

WHERE uploads.user = documents.user AND uploads.user = $userIDNum

ORDER BY uploads.title ASC, documents.title ASC";

[bregent]

You'll need to explain a little more about your data and what you are trying to accomplish. Your current sql will select all columns from both the uploads and documents tables but only rows where the user id in both tables match, AND the user id equals 1. Is that not what you are seeing? Where's the code that outputs the results?