Field Management, working with other than CB tables

Thank you for your consideration, I searched but did not find anything.
I have some tables in my database such as zip code, job titles and office directory which I would like to include as select fields in my profiles.
You have a field labeled "param" which enables selecting "user parameters".
How can I (if possible) create that field using my "zip code" or "directory" tables?
I attempted a query SELECT fld_zipcode FROM w5x27_zipcode but it did not populate the dropdown.
Does this mean those fields have to be created in cb first? Is it possible to create a table in CB?
Thanks again for your time and consideration!!

The params field is for rendering Joomla userparams. It sounds like you want to have a dropdown select field with options pulled from a separate database table. For that you need to use CB Query Field. Please see the below tutorial videos regarding CB Query Field.

www.youtube.com/playlist?list=PLp0puRITgC7MM9iP9FooKB1qk8f5MLWVp

We also have the below tutorial.

www.joomlapolis.com/support/tutorials/107-use-cases/18377-configuring-a-country-field-with-cb-query-field-plugin

Thank you again,
Actually I want to create a "CB Tab" with all the fields from that table whereby the information can be updated. There is about 35 fields in the table of which 18 require updating twice a year. The names entered into the fields are selected from "CB User Management" which needs to be filtered based on "Office".
By the way, I managed to get the SELECT syntax corrected, removed the quote marks.

You want to display information from a different database table on a profile tab? That's also doable by CB Query Field. Beyond that I don't understand what you're trying to do. If they're just standard fields that you need then create them in CB > Field Management and place them on whatever tab you like (you can create new tabs in CB > Tab Management).

Thank you, I will use the query field option, I was hoping to pull all those fields at one time as with your "param" field.
Thanks again.

The query field supports custom multi-column output so you could pull all the information you're wanting at once then format it however you need using HTML and substituting in the columns. The params field doesn't query anything and is just values from the Joomla user object.

Another option is to create standard fields in CB > Field Management then use CB Auto Actions and a query action to synchronize the two tables using an update query. As long as something links them together like their user id then it should work fine to synchronize the data on every login or however you'd like to do it. This would eliminate having any additional queries at all except for the synchronize query.