Hi,
I have two tables:
#TB1
ID_tb1 (auto-incremented)
ID_tb2
name
address
#TB2
ID_tb2 (auto-incremented)
method
status
I need tu run a query that inserts values into #TB1 and #TB2, having #TB1.ID_tb2 equal to #TB2.ID_tb2.
Since #TB2.ID_tb2 is auto incremented, I don't know how to get the same value inserted at #TB1.ID_tb2...
Thanks in advance.
Best Regards,
jO
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
I have two tables:
#TB1
ID_tb1 (auto-incremented)
ID_tb2
name
address
#TB2
ID_tb2 (auto-incremented)
method
status
I need tu run a query that inserts values into #TB1 and #TB2, having #TB1.ID_tb2 equal to #TB2.ID_tb2.
Since #TB2.ID_tb2 is auto incremented, I don't know how to get the same value inserted at #TB1.ID_tb2...
Thanks in advance.
Best Regards,
jO
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->