OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » 3 tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

3 tables [message #293666]

Mon, 14 January 2008 08:42

totalhate
Messages: 2
Registered: January 2008

Junior Member

Hello,

I have 3 tables "selektion" ("kndnr" [pk], "werbecode"), "xkundenadrassen" (kndnr[sk], "kndnrart"[pk], "vorname1", "nachname1") and "xkundentitel"("kndnrart"[pk/sk], "titel1"). I need a file with all data from "selektion" where "werbecode" = 221000. In addition, I need the attributes from the "xkundentitel" and "xkundenadresse".

For each data in "selektion" in the table "xkundentitel" are until 9 datas. I need for each data from "selektion" one line (all with the same length.

Report message to a moderator

Re: 3 tables [message #293668 is a reply to message #293666]

Mon, 14 January 2008 08:45

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So what did you try?
Read Joins

Also, please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button to verify.
Always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator

Re: 3 tables [message #293672 is a reply to message #293666]

Mon, 14 January 2008 09:13

totalhate
Messages: 2
Registered: January 2008

Junior Member

I use a Oracle 10g, in Attachments is a example, maybe that help to understand my problem

Attachment: Tables.doc
(Size: 31.00KB, Downloaded 471 times)

Report message to a moderator

Re: 3 tables [message #293684 is a reply to message #293672]

Mon, 14 January 2008 10:07

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read OraFAQ Forum Guide, many of us can't/don't dowload doc files.

By the way, I understand the problem. Did you understand my previous link?

Regards
Michel

[Updated on: Mon, 14 January 2008 10:08]

Report message to a moderator

Previous Topic:	sql query failing with order by
Next Topic:	get null record with 0 value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 13 00:35:03 CST 2024