Need a better SELECT

[marra1]

One of my tables is sales. This list all of our salespeople. The problem I am running into is that thier are always 2 salespeople. Here is my current select statement that returns nothing.

SELECT deals.dateWritten, dept.dept, deals.cust, sales.sales AS sales1, sales.sales AS sales2, salesmgr.salesmgr, fimgr.fimgr, deals.stockNum, deals.dealNum, dealType.dealType, dealStatus.dealStatus, deals.comment
FROM deals, dept, sales, salesmgr, fimgr, dealType, dealStatus
WHERE deals.deptID = dept.deptID AND deals.sales1ID = sales.salesID AND deals.sales2ID = sales.salesID AND deals.salesmgrID = salesmgr.salesmgrID AND deals.fimgrID = fimgr.fimgrID AND deals.dealTypeID = dealType.dealTypeID AND deals.dealStatusID = dealStatus.dealStatusID LIMIT 0 , 30;

If I take out the part that relates to deals.sales2ID it works great. I just don't get my second sales person returned.

[bd4rr]

Try this:

SELECT deals.dateWritten, dept.dept, deals.cust, s1.sales AS sales1, s2.sales AS sales2, salesmgr.salesmgr, fimgr.fimgr, deals.stockNum, deals.dealNum, dealType.dealType, dealStatus.dealStatus, deals.comment
FROM deals, dept, sales s1, sales s2, salesmgr, fimgr, dealType, dealStatus
WHERE deals.deptID = dept.deptID AND deals.sales1ID = s1.salesID AND deals.sales2ID = s2.salesID AND deals.salesmgrID = salesmgr.salesmgrID AND deals.fimgrID = fimgr.fimgrID AND deals.dealTypeID = dealType.dealTypeID AND deals.dealStatusID = dealStatus.dealStatusID LIMIT 0 , 30;

Hope I got it right.

Ken

[marra1]

Ken,

Yes, you did get it right. Thanks a bunch. That worked great.