Hi, I posted this in 'misc questions' and was directed here. Am starting to teach myself SQL. I cannot figure out how to do the most simple of queries, and it is driving me nuts. Here's the basic scenario:
Table: Customer
custid
firstname
lastname
Table: Transactions
custid
transdate
transamount
I want a query which will display ALL customers and any associated transactions. However, the query I used (below) only returns the customer if there is a transaction for it. For customers with no transactions, they are not being listed and I need help to show me how to structure the query to that the listing of the master table is not dependent on there being any child records in existence.
Code: ( sql )
SELECT customer.custid, customer.firstname, customer.lastname, transactions.transdate, transactions.transamount
FROM customer, transactions WHERE customer.custid=transactions.custid
Please tell me where I am going wrong!!!
3 1049
Hi, I posted this in 'misc questions' and was directed here. Am starting to teach myself SQL. I cannot figure out how to do the most simple of queries, and it is driving me nuts. Here's the basic scenario:
Table: Customer
custid
firstname
lastname
Table: Transactions
custid
transdate
transamount
I want a query which will display ALL customers and any associated transactions. However, the query I used (below) only returns the customer if there is a transaction for it. For customers with no transactions, they are not being listed and I need help to show me how to structure the query to that the listing of the master table is not dependent on there being any child records in existence.
Code: ( sql )
SELECT customer.custid, customer.firstname, customer.lastname, transactions.transdate, transactions.transamount
FROM customer, transactions WHERE customer.custid=transactions.custid
Please tell me where I am going wrong!!!
Google left outer join
Perfect, thank you very much!
Perfect, thank you very much!
Google is our friend
Sign in to post your reply or Sign up for a free account.
Similar topics
by: DH |
last post by:
I have a VERY basic question about figuring database size. I've inherited a
database which is generally similar to this basic one:
Item, Red, Blue, Green, Yellow
(text), (int),(int),(int),(int)...
|
by: http://vmdd.tech.mylinuxisp.com/catalog/ |
last post by:
After having seen my co-worker reinventing the wheel
when he busily labored to build MS Access framework, I want to share
my perspective.
Having experienced with Access, Visual Basic, Visual...
|
by: Servé Lau |
last post by:
in what fields of computing is C used the most nowadays?
embedded, scientific, applications? What?
|
by: Ramesh |
last post by:
hi,
Let me ask some basic questions.
Can anybody explain me about the following questions:
1. When we have to create sn key? Whenever we compiled
Component we have to create or it is a one time...
|
by: Pete |
last post by:
I'm cross posting from mscom.webservices.general as I have received no answer
there:
There has been a number of recent posts requesting how to satisfactorily
enable BASIC authorization at the...
|
by: Aussie Rules |
last post by:
Hi,
Having a mental block on this one. Have done it before but can't rack my
brain on how...
I have an object, with a bunch on property, and I add that object to a combo
box. I want the...
|
by: Sector 7G |
last post by:
I'm working with a SQL query for a Human Resources database. Its intended purpose is to find all the paycheck records with a check date (prckhist.chkdate ) more recent than eleven days past the...
|
by: Chris Asaipillai |
last post by:
Hi there
My compay has a number of Visual Basic 6 applications which are front endeed onto
either SQL Server or Microsoft Access databases.
Now we are in process of planning to re-write these...
|
by: kerry2807 |
last post by:
Hi, Am starting to teach myself SQL. I cannot figure out how to do the most simple of queries, and it is driving me nuts. Here's the basic scenario:
Table: Customer
custid
firstname
lastname...
|
by: Scott Stark |
last post by:
Hello,
I'm trying to get a better handle on OOP programming principles in VB.NET.
Forgive me if this question is sort of basic, but here's what I want to do.
I have a collection of Employee...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |