Table Names

40 pts.
Tags:
tables
What are these table names:
0
0
1
23
136
Rentpath
1
1
158
14.0
And:
select c.customer_id, o.organization_key, o.extn_dc
from yfs_customer c, yfs_organization o
where c.customer_id = o.organization_key
and o.extn_dc = '005'
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    Your question is not clear.

    Please try to re-write it.
    84,805 pointsBadges:
    report
  • Shellken69
    Sorry, wrong query..Here it is: 0 0 1 43 246 Rentpath 2 1 288 14.0

    List the table name

    Circle the join conditions

    How many columns will be returned

     

    SELECT G1.Store_Name STORE, SUM(G2.Sales) SALES

     FROM Geography G1

     INNER JOIN Store_Information G2

     ON G1.Store_Name = G2.Store_Name

     GROUP BY G1.Store_Name;

40 pointsBadges:
report
  • Shellken69

    List the table name

    Circle the join conditions

    How many columns will be returned

     

    SELECT G1.Store_Name STORE, SUM(G2.Sales) SALES

     FROM Geography G1

     INNER JOIN Store_Information G2

     ON G1.Store_Name = G2.Store_Name

     GROUP BY G1.Store_Name;

    40 pointsBadges:
    report
  • carlosdl
    Oh, I see.  That is your homework. 

    We wouldn't be doing you any favor answering that.
    84,805 pointsBadges:
    report
  • Shellken69
    No actually it isn't, but I figured it out. Thanks anyway. 
    40 pointsBadges:
    report
  • Forgot Password

    No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

    Your password has been sent to:

    To follow this tag...

    There was an error processing your information. Please try again later.

    Thanks! We'll email you when relevant content is added and updated.

    Following

    Share this item with your network: