select * from table_a, table_b

Posted on 2009-02-08
Last Modified: 2012-05-06
i want to give the following command

select * from table_a, table_b
  where   ........

i want the * to be used in such a way in order to include the fields from table_a only .  is it possible? i am using oracle 9i
Question by:basilhs_s
    LVL 6

    Accepted Solution


    if you need to select all items from table_a only so why do you want to keep table_b with you?

    select * from table_A inner join Table_b where
    table_A.X = table_B.x

    where X is the commen row between the 2 tables.

    Best Regards,

    Mohamed Allam
    Senior Software Engineer
    LVL 22

    Assisted Solution

    SELECT *
    FROM table_a
     (SELECT 1
      FROM table_b
      WHERE  table_a.col =  table_b.col) ;
    LVL 16

    Assisted Solution

    select table_a.* from table_a, table_b
      where   ........

    LVL 6

    Assisted Solution

    select  a.* from table_a ta, table_b tb
      where   ta.col = tb.col;


    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Introduction Hopefully the following mnemonic and, ultimately, the acronym it represents is common place to all those reading: Please Excuse My Dear Aunt Sally (PEMDAS). Briefly, though, PEMDAS is used to signify the order of operations (http://en.…
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now