February 8, 2021 at 12:16 pm
Hi,
If a person has got two addresses then I need post a letter for both the addresses otherwise post to the letter to the family address which is one.
SELECT id,
,firstname
,lastname
,address
,postcode
From constituent
The data I have is as below:
10001,Esther,Wheels,101 Rosehill, WA1878,sue.w@hotmail.com
10001,Esther,wheels,30 miles rd, 123UDF,hws.isthe@hotmail.com
10001,Esther,Wheels,101 Rosehill, WA1878,
How to put this information in a single row showing id,firstname,lastname, address1,postcode1,address2,postcode2,email1,email2,First Family(flag), Second family(x)? If there is no second address it should show just one address.
Please help?
February 8, 2021 at 3:33 pm
How to put this information in a single row showing id,firstname,lastname, address1,postcode1,address2,postcode2,email1,email2,First Family(flag), Second family(x)? If there is no second address it should show just one address.
What do First Family(flag) and Second family(x) signify?
Are you condensing to a single row based on the Id column? So one row required for every Id?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
February 8, 2021 at 5:34 pm
Please post the DDL for the table and an insert statement for data. (CREATE TABLE and INSERT..VALUES)
This will help us help you find a solution. Show the results you would like, given the sample data and any queries you've tried.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply