error in running the join query

[progvar]

Hi!
i am facing a probleum while excuting the query having join operator
i am using sql server 6.0 and my query is

Select BABLU.COM_NAME,BABLU.INDNT,VEER.ADDRESS From BABLU Join VEER on BABLU.COM_NAME = VEER.COM_NAME

[radcaesar]

What is the error u r getin ?

[progvar]

Hi
THIS IS THE ERROR " SYNTAX ERROR NEAR VEER"

What is the error u r getin ?

[ck9663]

Try specifying if you want an INNER, LEFT or RIGHT join...

-- CK

[progvar]

HI!
NO ONE EXECUTED CORRECTLY, EVERY JOIN WHETHER IT IS INNER JOIN ,LEFT OR RIGHT JOIN
PLEASE PROVIDE SOME HELP

Try specifying if you want an INNER, LEFT or RIGHT join...

-- CK

[ck9663]

Please provide more info.

Paste same sample rows (it does not have to be the actual data) here and the query what you have so far.

-- CK

[progvar]

Hi!
i have two tables customer and sales in both tables "cus_id " column name is common and i am using the query

SELECT CUSTOMER.FIRST_NAME,CUSTOMER.LAST_NAME,SALES.DATE FROM CUSTOMER LEFT OUTER JOIN SALES
ON CUSTOMER.CUS_ID = SALES.CUS_ID
i want to get all the rows from customer tables and some from sales which matched in both tables

with regareds
varinder

Please provide more info.

Paste same sample rows (it does not have to be the actual data) here and the query what you have so far.

-- CK

[ck9663]

What error are you getting?

-- CK

[progvar]

SYNTAX ERROR NEAR JOIN
BUT I AM NOT GETTING WHAT IS WRONG IN MY CODE

What error are you getting?

-- CK

[deric]

Have you tried using aliases?

SELECT C.FIRST_NAME,C.LAST_NAME,S.DATE FROM CUSTOMER C LEFT OUTER JOIN SALES S
ON C.CUS_ID = S.CUS_ID

And if you'd like to get only the rows that has the same CUS_ID from both tables then you might want to use INNER JOIN.

[progvar]

Hi
THIS QUERY IS ALSO SHOWING THE SAME ERROR
"INCORRECT SYNTAX NEAR LEFT"

Have you tried using aliases?

SELECT C.FIRST_NAME,C.LAST_NAME,S.DATE FROM CUSTOMER C LEFT OUTER JOIN SALES S
ON C.CUS_ID = S.CUS_ID

And if you'd like to get only the rows that has the same CUS_ID from both tables then you might want to use INNER JOIN.

[ck9663]

Where are you running this?

-- CK

[progvar]

Hi!
I AM RUNNING THIS QUERY IN SQL SERVER 6.0 QUERY ANALYZER

Where are you running this?

-- CK

[ck9663]

Hi!
I AM RUNNING THIS QUERY IN SQL SERVER 6.0 QUERY ANALYZER

The query seems to be correct...

SELECT C.FIRST_NAME,C.LAST_NAME,S.DATE 
FROM CUSTOMER C 
LEFT OUTER SALES S ON C.CUS_ID = S.CUS_ID

-- CK

[deric]

I don't know if SQL Server 6.0 can support Join statements.. I don't have version 6.0 here.

You may code it differently, like:

SELECT CUSTOMER.FIRST_NAME, CUSTOMER.LAST_NAME, SALES.DATE
FROM CUSTOMER, SALES
WHERE CUSTOMER.CUS_ID = SALES.CUS_ID

The difference of that query from the query with Join statement is that Join statement could retrieve data faster.