awk getline help maybe?

hello collegues,

I am attempting to use awk to search file1 (serverlist.csv) from each row with file2 (supported.txt). If the is no entry exists in serverlist then output to a file called notsupp.out if there is an entry output to supp.out

I can do this with basic shell scripting however would like to use awk and understand the syntax as the file I am searching is rather large.

here is what I got so far:

awk 'BEGIN{while (getline LINE < "serverlist.csv") > 0);{print LINE}' supported.txt

I would have expected this to print all lines that match however everthing prints :frowning:

any help is greatly appreciated!

Thanks

Chris