Home » SQL & PL/SQL » SQL & PL/SQL » 3 tables
3 tables [message #293666] Mon, 14 January 2008 08:42 Go to next message
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.
Re: 3 tables [message #293668 is a reply to message #293666] Mon, 14 January 2008 08:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: 3 tables [message #293672 is a reply to message #293666] Mon, 14 January 2008 09:13 Go to previous messageGo to next message
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 126 times)
Re: 3 tables [message #293684 is a reply to message #293672] Mon, 14 January 2008 10:07 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Sat Dec 10 20:37:54 CST 2016

Total time taken to generate the page: 0.08142 seconds