Please, read the comments to the question first.
I'd suggest to start with basics:
Tutorial: Writing Transact-SQL Statements | Microsoft Docs[
^]
As Bruno (
0x01AA[
^]) mentioned in the comment to the question, to fetch data, you have to use
SELECT statement[
^]. You can "link" 2 tables by using
joins[
^], see:
Visual Representation of SQL Joins[
^]
So, an example SELECT statement can look like this:
SELECT so.OperationId, so.Stuff, so.ClientId, ci.ClientName
FROM SellOperation AS so INNER JOIN Clients AS ci ON so.ClientId = ci.ClientId
WHERE so.ClientId = @ClientId
Good luck!