Article View: borland.public.interbase.sql
Article #272Help with a join.,..
From: Todd Frankson
Date: Thu, 14 Feb 2008 21:24
Date: Thu, 14 Feb 2008 21:24
20 lines
1298 bytes
1298 bytes
I have 2 tables, basically the same structure....the important fields are the ones that are named the same. Table 1 ID, Visit, A,b,c....... Table 2 ID, Visit, a,g,f..... I need to combine the two tables in a view(or 3rd table as last resort) there are limits to what data I need... For example, The ID might be in both tables, if so I need the one that the visit is not NULL but if the ID is in only one table, take it even if it is null Can anyone get me started on this one??? Thanks in advance
Technical Details
Message-ID:
<47b4b0fa$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,81f9d25eabdd893f,start X-Google-Attributes: gid114a0e,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit From: "Todd Frankson" <tfrankson@medtrials.com> Newsgroups: borland.public.interbase.sql Subject: Help with a join.,.. Date: Thu, 14 Feb 2008 16:24:08 -0500 Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1914 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914 NNTP-Posting-Host: 65.91.40.242 Message-ID: <47b4b0fa$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1203024122 65.91.40.242 (14 Feb 2008 13:22:02 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail