SQL server question

• urvasjets

  SSC Rookie

  Points: 33

  More actions

  June 17, 2022 at 3:25 pm

  #4051035

  Hi,

  I am just starting learning SQL..

  I need help:

  I want to create a check constraint for a column in Table1 so that it is smaller than another column value in another table?

  I tried join but it is not working!

• ratbak

  Default port

  Points: 1417

  More actions

  June 17, 2022 at 3:53 pm

  #4051067

  You would have to use a user-defined function to reference columns in other tables (which could have performance impacts).

  Your table design may be wrong if you have a column value that is dependent on/constrained by a column in  another table (other than a foreign key).

  Can you provide DDL & sample data (and descriptions if names/concepts are not obvious) for your tables per How to post code problems?

• urvasjets

  SSC Rookie

  Points: 33

  More actions

  July 14, 2022 at 8:44 am

  #4063156

  urvasjets wrote:

  Hi,

  I am just starting learning SQL..

  I need help: https://xender.vip/

  I want to create a check constraint for a column in Table1 so that it is smaller than another column value in another table?

  I tried join but it is not working!

   

  I got this,...