SQL Table Basics

SELECT *
FROM tbl_accounts
WHERE Login = 'MYUSERNAME'

PersID      Login   (many other COLUMNS...)
----------- ----------- ---------------------
4993        MYUSERNAME
________________________________________________________
SELECT *
FROM tbl_hardware_assignment
WHERE HW_ID >= 9777 AND HW_ID <= 9779

ID                  nameID      HW_ID         Since
------------------- ----------- ------------- -----------
22172               1541        9777          20100218
22173               1541        9777          20100218
22174               5296        9778          20100218
22175               5322        9779          20100218
22179               4401        9778          20100218
22182               4401        9779          20100218
35426               1541        9777          20130228
35951               1634        9778          20130502
35952               1634        9779          20130502
35953               5725        9779          20130502
36047               7546        9778          20130507
36995               1634        9778          20130619
37481               4993        9778          20130725

________________________________________________________
SELECT *
FROM tbl_hardware
WHERE HW_ID >= 9777 AND HW_ID <= 9779

HW_ID   KNH Serialnumber    Aktive      Comment Warantie    Accountingnumber    TypebrandmodelID
------- ------- --------------- --------------- ------- --------------- ----------------------- ---------------------
9777    11129   NULL            1       NULL    NULL        NULL            2839
9778    11130   KI24H9XZ203121  1       NULL    36      NULL            2868
9779    11131   KI24H9XZ117613  1       NULL    36      NULL            2868

________________________________________________________
SELECT
tbl_typebrandmodel.typebrandmodelID
FROM tbl_typebrandmodel
LEFT OUTER JOIN tbl_typ ON tbl_typebrandmodel.TypID = tbl_typ.TypID
LEFT OUTER JOIN tbl_brand ON tbl_typebrandmodel.BrandID = tbl_brand.BrandID
LEFT OUTER JOIN tbl_model ON tbl_typebrandmodel.ModelID = tbl_model.ModelID
WHERE tbl_typebrandmodel.BrandID= (SELECT tbl_brand.BrandID
                   FROM tbl_brand
                       WHERE tbl_brand.Lable LIKE 'Samsung'
                  )

typebradmodelID
---------------
864
1009
1013
1049
1062
1080
1084
1091
1145
1174
1184
1187
1195
1204
1205
1211
1213
1271
1336
1375
1455
1478
1535
1604
1618
1683
1703
1737
1756
1757
1802
1876
1877
1878
1892
1893
1910
1941
1943
2012
2017
2019
2024
2031
2036
2164
2178
2207
2211
2212
2219
2227
2270
2282
2295
2303
2306
2319
2358
2368
2446
2475
2541
2550
2561
2572
2573
2585
2598
2603
2604
2638
2644
2645
2646
2647
2648
2651
2652
2677
2680
2683
2696
2728
2729
2741
2742
2745
2807
2818
2819
2820
2821
2825
2828
2838
2862
2863
2867
2868
2895
2906
2907
2908
2913
2921
2932
2939
2942
2944
2966
2972
3038
3064
3131

(115 ROW(s) affected)