Hello
in a table i have this record set
RETAIL PRICE CUSTOMER PRICE Line Line up
2,199.0000 1,275.0000 Chev Chev nova
2,199.0000 1,275.0000 Chev Chev camaro
2,299.0000 1,333.0000 Chev Chev Impala
1,524.0000 1,265.0000 Dodge Dodge dart
1,624.0000 1,348.0000 Dodge Dodge ram
1,624.0000 1,348.0000 Dodge Dodge challenger
What I am trying to do is write a query that show
if the retail price and the customer price is the same put one line those recored chev and the different with model
ex
RETAIL PRICE CUSTOMER PRICE Line
2,199.0000 1,275.0000 Chev
2,299.0000 1,333.0000 Chev Impala
1,624.0000 1,348.0000 Dodge
1,624.0000 1,348.0000 Dodge challenger
Thanks
in a table i have this record set
RETAIL PRICE CUSTOMER PRICE Line Line up
2,199.0000 1,275.0000 Chev Chev nova
2,199.0000 1,275.0000 Chev Chev camaro
2,299.0000 1,333.0000 Chev Chev Impala
1,524.0000 1,265.0000 Dodge Dodge dart
1,624.0000 1,348.0000 Dodge Dodge ram
1,624.0000 1,348.0000 Dodge Dodge challenger
What I am trying to do is write a query that show
if the retail price and the customer price is the same put one line those recored chev and the different with model
ex
RETAIL PRICE CUSTOMER PRICE Line
2,199.0000 1,275.0000 Chev
2,299.0000 1,333.0000 Chev Impala
1,624.0000 1,348.0000 Dodge
1,624.0000 1,348.0000 Dodge challenger
Thanks