August 7, 2008 at 11:19 am
Hi members,
I have a query below like this
select t1.grandid, t1.parentid, t1.id, t1.classcode,convert(int,'2') as protectcode
from table1 t1 inner join table2
on t1.grandid=t2.grandid
and t1.parentid=t2.grandid
protectcode=t2.protectioncode
I actually have 4 columns that is grandid,parentid,id,classcode in table1 and I created a separate column protectcode in select statement.
My basic question is protectcode is the column which is not there in table1 but there is protectioncode in table2 and i want to apply join based on column which is not there in table1
how should i solve this problem Should I take temp table with 4 columns and last column as protectcode and then apply join with table2 or what??
Thanks,
sainath
August 7, 2008 at 11:25 am
I'm not sure why you do the convert(int, '2') instead of just 2, but if you are setting a constant you can just use the constant in your join. Like this:
[font="Courier New"]SELECT
t1.grandid,
t1.parentid,
t1.id,
t1.classcode,
CONVERT(INT,'2') AS protectcode
FROM
table1 t1 INNER JOIN
table2 ON
t1.grandid=t2.grandid AND
t1.parentid=t2.grandid AND
CONVERT(INT,2)=t2.protectioncode[/font]
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 7, 2008 at 1:56 pm
Hi jack,
Thanks a lot.
I issue is resolved.
Thanks,
sainath
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply