Tuesday, July 29, 2014

I'm asking simple question while I'm confused..


SELECT t1.custno,
t1.shipno,
t2.company,
t2.address,
t2.city,
t2.zip,
t2.state,
t2.email,
t2.faxno,
t2.phone
FROM tableFlorida t1
INNER JOIN tablebill t2
ON t1.custno = t2.custno
WHERE t1.tax <> ''
AND t1.state = 'FL'


No comments:

Post a Comment