Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
sql union problem
Name: intrepid_dave Date: June 14, 2005 at 03:47:14 Pacific OS: xp pro CPU/Ram: amd 3200+, 1 gig ram
Comment:
Hi, I wast to do a union of two tables in access:
table1 columns are: Postcode|Private|Business|
table2 columns are Postcode|Private|Business|Packs
The problem is i want to include Packs in the union and have null in that column for the table1 entries
How can i do this if the two table don't have matching columns as here?
Name: mdow Date: June 14, 2005 at 05:28:31 Pacific
Reply:
Create a subquery in your table1 select statement. Use the Nz function in your subquery to insert a value when you have a table1 record with no mathching table2 (Packs)record.
Summary: Hello, There is a SQL database that I normal run on Microsoft Access 97. When I specify from and to dates, the program generates a text file of record, which resides on the database server, with the ...
Summary: Please help !!! I am trying to complete an online form for replys from users The online form is meant to insert data retrieved from the users into a Ms Access Database's table (the db version is 2000...
Summary: Oracle 8i - SQL. I have a table that holds transactions. The primary key is id_number. There are thousands of unique id_numbers, but there are several id_numbers that have more than 1 transaction. I...
0 
