Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
Thread: Merging two record together
07-09-2014, 07:34 PM #1
- Join Date
- Mar 2006
- Thanked 0 Times in 0 Posts
Merging two record together
here's my records :
id client typeDemande 365665 900162 R 365666 900162 S 365667 900162 S 365668 900162 S
is there a way in SQl to get only one record if client has a typeDemande of R AND S?
07-10-2014, 04:58 PM #2
but... no clue what syntx to use as the database you are using isn't defined, and this has nothing to do with ASP- I'll flag for a MOD to move.Code:select distinct [client] where [typeDemande] = 'R' and [typeDemande] = 'S'
07-10-2014, 05:41 PM #3