Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by cronid

  1. cronid

    select * for one of two tables in a join

    Thanks. That works. I did try that earlier, but my syntax must have been incorrect.
  2. cronid

    select * for one of two tables in a join

    I have two tables, SMTR and CASE, which can easily be joined as below. I want a view which has all 10 columns of SMTR and the division column from CASE. I can get it by listing the 10 SMTR columns but I'd like to use an * for just SMTR, and specify the division column from CASE. Can this sql be...
    • cronid
    • Thread
    • Replies: 2
    • Forum: SQL
See more

Part and Inventory Search

Back
Top