Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations cowski 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 Bottom