• Ok,column which is having identity will be parent table and second one will act as as child

    and yes if column name is same both tables then only query will work else need to do some manual work