# Join operation in Aerospike node client

**URL:** <https://discuss.aerospike.com/t/join-operation-in-aerospike-node-client/4809>\
**Category:** Node.js Client\
**Tags:** query, mysql\
**Created:** [December 11, 2017, 2:20pm UTC](https://discuss.aerospike.com/t/join-operation-in-aerospike-node-client/4809 "2017-12-11T14:20:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nikunj\_Patel](https://avatars.discourse-cdn.com/v4/letter/n/9dc877/32.png) [@Nikunj\_Patel](https://discuss.aerospike.com/u/Nikunj_Patel)\
**Post date:** [December 11, 2017, 2:20pm UTC](https://discuss.aerospike.com/t/join-operation-in-aerospike-node-client/4809/1 "2017-12-11T14:20:26Z")

</div>

Can I do join operations like SQL. Or I want to get data from two tables in single query. Which is efficient way to get records?

---

<div class="post-metadata">

**Author:** ![Jan](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/jan/32/1124_2.png) [@Jan](https://discuss.aerospike.com/u/Jan)\
**Post date:** [December 11, 2017, 5:43pm UTC](https://discuss.aerospike.com/t/join-operation-in-aerospike-node-client/4809/2 "2017-12-11T17:43:47Z")

</div>

Aerospike does not support join operations. You can retrieve multiple records in a single queries using [batch reads](https://www.aerospike.com/apidocs/nodejs/Client.html#batchRead). However, you do need to know the primary keys of all the records you want to fetch.