Urgent Oracle SQL Question (INNER JOIN)

[Platypus]

Hi folks,

I have two tables, one containing detail records and one containing header records. The common columns are let's say CODE and CLIENT.

What I want to do is to select info from the detail records but join to the header record, like this:

SELECT
A.CODE, A.CLIENT, A.NAME,
B.DATE, B.AMOUNT
FROM HEADER A
INNER JOIN DETAIL B something

The pseudo-code for "something" is

FOR RECORDS WHERE A.CLIENT = B.CLIENT AND A.CODE = B.CODE

I think I can do it like this:

INNER JOIN ON A.CLIENT = B.CLIENT AND A.CODE = B.CODE

or

INNER JOIN ON A.CLIENT||A.CODE = B.CLIENT||B.CODE

Or would this do the same / be better ?

USING (CLIENT, CODE)

I don't have access to the target system, so I'm giving the local oppo instructions by email. It would be excellent if what I told him worked!

Thanks in advance!!

[Spacecadet]

Select
A.code, A.client, A.name,
B.date, B.amount
From Header A
Inner Join Detail B
on
A.client = B.client
And A.code = B.code

[Platypus]

Select
A.code, A.client, A.name,
B.date, B.amount
From Header A
Inner Join Detail B
on
A.client = B.client
And A.code = B.code

Many thanks!

What's the approved CUK way of sending free beers in gratitude?

[Spacecadet]

Many thanks!

What's the approved CUK way of sending free beers in gratitude?

http://www.beer4home.co.uk/

[TheFaQQer]

Why not

SELECT a.code
,      a.client
,      a.name
,      b.date
,      b.amount
from   header a
,      detail b
where  a.client = b.client
and    a.code   = b.code

?

Oh - and "date" is a really bad name for a column, since it's a reserved word.

[Spacecadet]

Why not

SELECT a.code
,      a.client
,      a.name
,      b.date
,      b.amount
from   header a
,      detail b
where  a.client = b.client
and    a.code   = b.code

?

Oh - and "date" is a really bad name for a column, since it's a reserved word.

that would work fine too, technically no reason not to
Personally I'd say that good practice dictates otherwise though

[MrRobin]

that would work fine too, technically no reason not to
Personally I'd say that good practice dictates otherwise though

Yeah it's not proppa ansi SQL innit.

[PAH]

I don't have access to the target system, so I'm giving the local oppo instructions by email. It would be excellent if what I told him worked!

Sure, we believe you. Cheating on a technical test, naughty.

[Platypus]

Sure, we believe you. Cheating on a technical test, naughty.

Actually, working on Plan B

[Platypus]

Oh - and "date" is a really bad name for a column, since it's a reserved word.

I simplified the statement so az yu lot cud undast& it like!