Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
marvin87
Starting Member
1 Post |
Posted - 2014-04-15 : 07:34:41
|
Hey guys,In need of some assistance.Datafields and tables are below:HeadersFolio Our Ref Your Ref Date Posted 54905 PIN003572 27367 18/01/2013 31/01/201354999 PIN003617 3033475 18/01/2013 31/01/201359999 SIN024969 03/01/2013 31/01/2013PostingsFolio Our Ref Your Ref Date Posted54905 Accommodation Null Null Null54999 Professional Services Null Null Null54999 Filing Fee Null Null Null59999 2013 Motor Null Null Null59999 2013 Household Null Null NullI received 1 dataset in Excel format and I created the Headers table from this 1 table by filtering on the rows which had dates populated in them, the remaining data (with NULL entries) was pasted into the Postings table. Each row in the headers table is unique. I therefore need to merge this data and populate the postings table Null entries with it. As you can see the posting entries are not unique by looking at the FOLIO numbers.How would I go about doing this? I've been told to look up Full outer joins but I don't have a clue what that means!!!Literally just started using SQL! HELP! |
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2014-04-15 : 08:59:39
|
You can put tags [C0DE][/C0DE] around to display your post formatted.Do you want a SELECT only to show the completed data or do you want to make permanent changes to the table "Postings"?HeadersFolio Our Ref Your Ref Date Posted 54905 PIN003572 27367 18/01/2013 31/01/201354999 PIN003617 3033475 18/01/2013 31/01/201359999 SIN024969 03/01/2013 31/01/2013PostingsFolio Our Ref Your Ref Date Posted54905 Accommodation Null Null Null54999 Professional Services Null Null Null54999 Filing Fee Null Null Null59999 2013 Motor Null Null Null59999 2013 Household Null Null Null Too old to Rock'n'Roll too young to die. |
|
|
|
|
|