I have 2 tables - Master plan table and detail table. The plan number is unique in Master plan table and repeats in detail table. There is another column in detail table called planrefnumber that is text, contains values such as 'myp-01-pcs', 'myp-02-pcs', 'myp-03-pcs' and so on.
Based on the value of the column 'planrefnumber' , I want to display a new column that has a 'yes' if planrefnumber = 'myp-01-pcs'. If planrefnumber = 'myp-02-pcs',...
hexleena
Last Activity: Mar 25 '08, 06:23 PM
Joined: Mar 14 '08
Location:
-
display in a column format
-
please help...it is not displaying the correct result. -
Hi,
I looked at the result but it looks like it is also displaying the duplicate records, meaning same vin_no with same address appears more than once....can we eliminate duplicates?
also we need to add a condition where sender_id = 'GMCA'
Thanks.Leave a comment:
-
This helped, I think!!
Thanks a lot!!!Leave a comment:
-
Display non-distinct records in sql
Hi,
I have a table with many columns but am concerned with only 2 columns - vin_no and address. I have repeating address and different vin nos. , also repeating address and same vin nos.
I want the following:
Display repeating addresses with different vin nos ONLY. It should not display records that have same vin nos.
How is this possible?
Thanks.
No activity results to display
Leave a comment: